﻿using System;

namespace edowork.com.Model
{
    #region cityInfo

    [Serializable]
    public class cityInfo
    {
        #region Private fields

        protected string _cityid = String.Empty;
        protected string _cityname = String.Empty;
        protected string _provinceid = String.Empty;
        protected string _sysdate = String.Empty;

        #endregion

        public cityInfo() { }

        #region Public Properties

        public string Cityid
        {
            get { return _cityid; }
            set { _cityid = value; }
        }

        public string Cityname
        {
            get { return _cityname; }
            set { _cityname = value; }
        }

        public string Provinceid
        {
            get { return _provinceid; }
            set { _provinceid = value; }
        }

        public string Sysdate
        {
            get { return _sysdate; }
            set { _sysdate = value; }
        }

        #endregion

        #region Public SQL Script

        public string SQL_Insert()
        {
            return "insert into city(Cityid,Cityname,Provinceid,Sysdate) values('{0}','{1}','{2}','{3}')";
        }

        #endregion

    }

    #endregion
}

